CREATE TABLE [dbo].[Analysis_audit] (
[AuditId] [bigint] IDENTITY (1, 1) NOT NULL,
[pk_Analysis] [uniqueidentifier] NOT NULL,
 [fk_AnalysisMaster] [uniqueidentifier] NOT NULL,
 [Letter] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [AnalysisID] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [AnalysisShort] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [fk_SpecificationTemplate] [uniqueidentifier] NOT NULL,
 [SpecificationTitle] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Traceability] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Objective] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ProjectName] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ProjectNumber] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [fk_CustomerContact] [uniqueidentifier] NOT NULL,
 [CorrectPO] [bit] NOT NULL,
 [CorrectParts] [bit] NOT NULL,
 [MeetsSpecification] [bit] NOT NULL,
 [RecommendCustomerReview] [bit] NOT NULL,
 [NoDetermination] [bit] NOT NULL,
 [Summary] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Conclusion] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [FailingItems] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ConformanceComment] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [PathCreated] [bit] NOT NULL,
 [DetailedSpecification] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Comment] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [InternalComment] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ExternalComment] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [IncludeCofC] [bit] NOT NULL,
 [IncludeFrontPageSignatures] [bit] NOT NULL,
 [IncludeCheckList] [bit] NOT NULL,
 [SandiaXRF] [bit] NOT NULL,
 [POConfirmed] [bit] NOT NULL,
 [POConfirmedBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [POConfirmedOn] [datetime] NOT NULL,
 [DueDateConfirmed] [bit] NOT NULL,
 [DueDateConfirmedBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [DueDateConfirmedOn] [datetime] NOT NULL,
 [PricingOption] [int] NOT NULL,
 [PricingOptionSetBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [PricingOptionEnteredOn] [datetime] NOT NULL,
 [Price] [numeric] (19,5) NOT NULL,
 [ChecklistEntered] [bit] NOT NULL,
 [ChecklistEnteredBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ChecklistEntryDate] [datetime] NOT NULL,
 [RiskAssessed] [bit] NOT NULL,
 [RiskAssessedBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [RiskAssessmentDate] [datetime] NOT NULL,
 [RiskNumber] [int] NOT NULL,
 [RiskMitigation] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ReceivingInspection] [bit] NOT NULL,
 [ReceivingInspectionBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ReceivingInspectionDate] [datetime] NOT NULL,
 [ConfigurationVerification] [bit] NOT NULL,
 [ConfigurationVerifiedBy] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ConfigurationVerificationDate] [datetime] NOT NULL,
 [Status] [int] NOT NULL,
 [ReceiveDate] [datetime] NOT NULL,
 [RequestDate] [datetime] NOT NULL,
 [DueDate] [datetime] NOT NULL,
 [StartDate] [datetime] NOT NULL,
 [CompleteDate] [datetime] NOT NULL,
 [CloseDate] [datetime] NOT NULL,
 [fk_ShippingMethod] [uniqueidentifier] NOT NULL,
 [fk_ShippingCourier] [uniqueidentifier] NOT NULL,
 [ShippingAccount] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [ShippingNotes] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [CheckListForm] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [QuoteNumber] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Legacy] [bit] NOT NULL,
 [Expedite] [bit] NOT NULL,
 [Assignee] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [PhotoPageStyle] [int] NOT NULL,
 [InvoiceNoteNOT NULL,
 [DockDate] [datetime] NOT NULL,
 [CustomerDate] [bit] NOT NULL,
 [ITAR] [bit] NOT NULL,
 [AuditAction] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
 [AuditDate] [datetime] NOT NULL ,
 [AuditUser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [AuditApp] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL)
